Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_OLAP2_DIM_HIER_LEVEL_USES

`ALL_OLAP2_DIM_HIER_LEVEL_USES` shows how levels are ordered within each hierarchy.

Within separate hierarchies, the same parent level may be hierarchically related to a different child level.

Column | Data Type | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the dimension.
`DIMENSION_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the dimension.
`HIERARCHY_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the hierarchy.
`PARENT_LEVEL_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the parent level.
`CHILD_LEVEL_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the child level.
`POSITION` | `NUMBER` | `NOT NULL` | Position of this parent-child relationship within the hierarchy, with position 1 being the most detailed.